{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2016-17","2017-18","Tax Formulas in Excel","Income Slabs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2016-17","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["FIN. YEAR","SEX","Code","Taxable Income","Income Tax Liability","Less: Rebate","Sub Total","Add: Surcharge","Total Tax","Add: Education Cess","Net Tax","SYSTEM","DIFF"]
["2016-2017","M","0003",150000,{"$f":"ROUND(IF(A2=\"2016-2017\",IF(OR(B2=\"M\",B2=\"F\"),IF(D2<=250000,0,IF(D2<=500000,(D2-250000)*10%,IF(D2<=1000000,(D2-500000)*20%+25000,(D2-1000000)*30%+125000))),0)+IF(B2=\"S\",IF(D2<=300000,0,IF(D2<=500000,(D2-300000)*10%,IF(D2<=1000000,(D2-500000)*20%+20000,(D2-1000000)*30%+120000))),0),0),0)","v":0},{"$f":"ROUND(IF(A2=\"2016-2017\",IF(D2<=500000,MIN(5000,E2),0),0),0)","v":0},{"$f":"E2-F2","v":0},{"$f":"IF(A2=\"2016-2017\",ROUND(IF(D2>10000000,IF(OR(B2=\"M\",B2=\"F\"),IF(D2>10646940,G2*15%,MAX((D2-10000000),0)*70%),IF(D2>10645800,G2*15%,MAX((D2-10000000),0)*70%)),0),0),0)","v":0},{"$f":"G2+H2","v":0},{"$f":"ROUND(I2*3%,0)","v":0},{"$f":"SUM(I2:J2)","v":0},0,{"$f":"L2-K2","v":0}]
["2016-2017","S","0004",{"$f":"D2+25000","v":175000},{"$f":"ROUND(IF(A3=\"2016-2017\",IF(OR(B3=\"M\",B3=\"F\"),IF(D3<=250000,0,IF(D3<=500000,(D3-250000)*10%,IF(D3<=1000000,(D3-500000)*20%+25000,(D3-1000000)*30%+125000))),0)+IF(B3=\"S\",IF(D3<=300000,0,IF(D3<=500000,(D3-300000)*10%,IF(D3<=1000000,(D3-500000)*20%+20000,(D3-1000000)*30%+120000))),0),0),0)","v":0},{"$f":"ROUND(IF(A3=\"2016-2017\",IF(D3<=500000,MIN(5000,E3),0),0),0)","v":0},{"$f":"E3-F3","v":0},{"$f":"IF(A3=\"2016-2017\",ROUND(IF(D3>10000000,IF(OR(B3=\"M\",B3=\"F\"),IF(D3>10646940,G3*15%,MAX((D3-10000000),0)*70%),IF(D3>10645800,G3*15%,MAX((D3-10000000),0)*70%)),0),0),0)","v":0},{"$f":"G3+H3","v":0},{"$f":"ROUND(I3*3%,0)","v":0},{"$f":"SUM(I3:J3)","v":0},0,{"$f":"L3-K3","v":0}]
["2016-2017","S","0004",{"$f":"D3+25000","v":200000},{"$f":"ROUND(IF(A4=\"2016-2017\",IF(OR(B4=\"M\",B4=\"F\"),IF(D4<=250000,0,IF(D4<=500000,(D4-250000)*10%,IF(D4<=1000000,(D4-500000)*20%+25000,(D4-1000000)*30%+125000))),0)+IF(B4=\"S\",IF(D4<=300000,0,IF(D4<=500000,(D4-300000)*10%,IF(D4<=1000000,(D4-500000)*20%+20000,(D4-1000000)*30%+120000))),0),0),0)","v":0},{"$f":"ROUND(IF(A4=\"2016-2017\",IF(D4<=500000,MIN(5000,E4),0),0),0)","v":0},{"$f":"E4-F4","v":0},0,{"$f":"G4+H4","v":0},0,0,0,0]
["2016-2017","S","0004",225000,0,0,0,0,0,0,0,0,0]
["2016-2017","S","0004",250000,0,0,0,0,0,0,0,0,0]

{"sheet":"2017-18","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["FIN. YEAR","SEX","Code","Taxable Income","Income Tax Liability","Less: Rebate","Sub Total","Add: Surcharge","Total Tax","Add: Education Cess","Net Tax","SYSTEM","DIFF"]
["2017-2018","M","0003",150000,{"$f":"ROUND(IF(A2=\"2017-2018\",IF(OR(B2=\"M\",B2=\"F\"),IF(D2<=250000,0,IF(D2<=500000,(D2-250000)*5%,IF(D2<=1000000,(D2-500000)*20%+12500,(D2-1000000)*30%+112500))),0)+IF(B2=\"S\",IF(D2<=300000,0,IF(D2<=500000,(D2-300000)*5%,IF(D2<=1000000,(D2-500000)*20%+10000,(D2-1000000)*30%+110000))),0),0),0)","v":0},{"$f":"ROUND(IF(A2=\"2017-2018\",IF(D2<=350000,MIN(2500,E2),0),0),0)","v":0},{"$f":"E2-F2","v":0},{"$f":"IF(A2=\"2017-2018\",ROUND(IF(D2>10000000,IF(OR(B2=\"M\",B2=\"F\"),IF(D2>10644080,G2*15%,MAX((D2-10000000),0)*70%),IF(D2>10620840,G2*15%,MAX((D2-10000000),0)*70%)),0)+IF(AND(D2>5000000,D2<=10000000),IF(OR(B2=\"M\",B2=\"F\"),IF(D2>5195890,G2*10%,MAX((D2-5000000),0)*70%),IF(D2>5195520,G2*10%,MAX((D2-5000000),0)*70%)),0),0),0)","v":0},{"$f":"G2+H2","v":0},{"$f":"ROUND(I2*3%,0)","v":0},{"$f":"SUM(I2:J2)","v":0},0,{"$f":"L2-K2","v":0}]
["2017-2018","M","0004",{"$f":"D2+25000","v":175000},{"$f":"ROUND(IF(A3=\"2017-2018\",IF(OR(B3=\"M\",B3=\"F\"),IF(D3<=250000,0,IF(D3<=500000,(D3-250000)*5%,IF(D3<=1000000,(D3-500000)*20%+12500,(D3-1000000)*30%+112500))),0)+IF(B3=\"S\",IF(D3<=300000,0,IF(D3<=500000,(D3-300000)*5%,IF(D3<=1000000,(D3-500000)*20%+10000,(D3-1000000)*30%+110000))),0),0),0)","v":0},{"$f":"ROUND(IF(A3=\"2017-2018\",IF(D3<=350000,MIN(2500,E3),0),0),0)","v":0},{"$f":"E3-F3","v":0},{"$f":"IF(A3=\"2017-2018\",ROUND(IF(D3>10000000,IF(OR(B3=\"M\",B3=\"F\"),IF(D3>10644080,G3*15%,MAX((D3-10000000),0)*70%),IF(D3>10620840,G3*15%,MAX((D3-10000000),0)*70%)),0)+IF(AND(D3>5000000,D3<=10000000),IF(OR(B3=\"M\",B3=\"F\"),IF(D3>5195890,G3*10%,MAX((D3-5000000),0)*70%),IF(D3>5195520,G3*10%,MAX((D3-5000000),0)*70%)),0),0),0)","v":0},{"$f":"G3+H3","v":0},{"$f":"ROUND(I3*3%,0)","v":0},{"$f":"SUM(I3:J3)","v":0},0,{"$f":"L3-K3","v":0}]
["2017-2018","M","0004",{"$f":"D3+25000","v":200000},0,0,0,0,0,0,0,0,0]
["2017-2018","M","0004",225000,0,0,0,0,0,0,0,0,0]
["2017-2018","M","0004",250000,0,0,0,0,0,0,0,0,0]
["2017-2018","M","0004",275000,1250,1250,0,0,0,0,0,0,0]
["2017-2018","M","0004",300000,2500,2500,0,0,0,0,0,0,0]
["2017-2018","M","0004",325000,3750,2500,1250,0,1250,38,1288,0,-1288]
["2017-2018","M","0004",350000,5000,2500,2500,0,2500,75,2575,0,-2575]

{"sheet":"Tax Formulas in Excel","index":2,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["FIN. YEAR","SEX","Code","Taxable Income","Income Tax Liability","Less: Rebate","Sub Total","Add: Surcharge","Total Tax","Add: Education Cess","Net Tax"]
["2019-2020","M",null,0,{"$f":"ROUND(IF(OR(A2=\"2019-2020\",A2=\"2018-2019\",A2=\"2017-2018\"),IF(OR(B2=\"M\",B2=\"F\"),IF(D2<=250000,0,IF(D2<=500000,(D2-250000)*5%,IF(D2<=1000000,(D2-500000)*20%+12500,(D2-1000000)*30%+112500))),0)+IF(B2=\"S\",IF(D2<=300000,0,IF(D2<=500000,(D2-300000)*5%,IF(D2<=1000000,(D2-500000)*20%+10000,(D2-1000000)*30%+110000))),0),0),0)+ROUND(IF(A2=\"2016-2017\",IF(OR(B2=\"M\",B2=\"F\"),IF(D2<=250000,0,IF(D2<=500000,(D2-250000)*10%,IF(D2<=1000000,(D2-500000)*20%+25000,(D2-1000000)*30%+125000))),0)+IF(B2=\"S\",IF(D2<=300000,0,IF(D2<=500000,(D2-300000)*10%,IF(D2<=1000000,(D2-500000)*20%+20000,(D2-1000000)*30%+120000))),0),0),0)","v":0},{"$f":"ROUND(IF(OR(A2=\"2018-2019\",A2=\"2017-2018\"),IF(D2<=350000,MIN(2500,E2),0),0),0)+ROUND(IF(A2=\"2016-2017\",IF(D2<=500000,MIN(5000,E2),0),0),0)+IF(A2=\"2019-2020\",IF(D2<=500000,MIN(12500,E2),0),0)","v":0},{"$f":"E2-F2","v":0},{"$f":"ROUND(IF(AND(A2=\"2019-2020\",B2<>\"S\"),IF(D2<=5000000,0,IF(D2<=5195890,(D2-5000000)*70%,IF(D2<=10000000,G2*10%,IF(D2<=10214700,(D2-10000000)*70%+281250,IF(D2<=20000000,G2*15%,IF(D2<=20930000,(D2-20000000)*70%+871875,IF(D2<=50000000,G2*25%,IF(D2<=53017830,(D2-50000000)*70%+3703125,G2*37%)))))))),0),0)+ROUND(IF(AND(A2=\"2019-2020\",B2=\"S\"),IF(D2<=5000000,0,IF(D2<=5195530,(D2-5000000)*70%,IF(D2<=10000000,G2*10%,IF(D2<=10214510,(D2-10000000)*70%+281000,IF(D2<=20000000,G2*15%,IF(D2<=20929600,(D2-20000000)*70%+871500,IF(D2<=50000000,G2*25%,IF(D2<=53017320,(D2-50000000)*70%+3702500,G2*37%)))))))),0),0)+IF(OR(A2=\"2018-2019\",A2=\"2017-2018\"),ROUND(IF(D2>10000000,IF(OR(B2=\"M\",B2=\"F\"),IF(D2>=10214700,G2*15%,MAX((D2-10000000),0)*70%+281250),IF(D2>=10214510,G2*15%,MAX((D2-10000000),0)*70%+281000)),0)+IF(AND(D2>5000000,D2<=10000000),IF(OR(B2=\"M\",B2=\"F\"),IF(D2>5195890,G2*10%,MAX((D2-5000000),0)*70%),IF(D2>5195530,G2*10%,MAX((D2-5000000),0)*70%)),0),0),0)+IF(A2=\"2016-2017\",ROUND(IF(D2>10000000,IF(OR(B2=\"M\",B2=\"F\"),IF(D2>10646940,G2*15%,MAX((D2-10000000),0)*70%),IF(D2>10645800,G2*15%,MAX((D2-10000000),0)*70%)),0),0),0)","v":0},{"$f":"G2+H2","v":0},{"$f":"ROUND(IF(OR(A2=\"2019-2020\",A2=\"2018-2019\"),(I2*4%),(I2*3%)),0)","v":0},{"$f":"SUM(I2:J2)","v":0}]
["2019-2020","S",null,0,0,0,0,{"$f":"ROUND(IF(AND(A3=\"2019-2020\",B3<>\"S\"),IF(D3<=5000000,0,IF(D3<=5195890,(D3-5000000)*70%,IF(D3<=10000000,G3*10%,IF(D3<=10214700,(D3-10000000)*70%+281250,IF(D3<=20000000,G3*15%,IF(D3<=20930000,(D3-20000000)*70%+871875,IF(D3<=50000000,G3*25%,IF(D3<=53017830,(D3-50000000)*70%+3703125,G3*37%)))))))),0),0)+ROUND(IF(AND(A3=\"2019-2020\",B3=\"S\"),IF(D3<=5000000,0,IF(D3<=5195530,(D3-5000000)*70%,IF(D3<=10000000,G3*10%,IF(D3<=10214510,(D3-10000000)*70%+281000,IF(D3<=20000000,G3*15%,IF(D3<=20929600,(D3-20000000)*70%+871500,IF(D3<=50000000,G3*25%,IF(D3<=53017320,(D3-50000000)*70%+3702500,G3*37%)))))))),0),0)+IF(OR(A3=\"2018-2019\",A3=\"2017-2018\"),ROUND(IF(D3>10000000,IF(OR(B3=\"M\",B3=\"F\"),IF(D3>=10214700,G3*15%,MAX((D3-10000000),0)*70%+281250),IF(D3>=10214510,G3*15%,MAX((D3-10000000),0)*70%+281000)),0)+IF(AND(D3>5000000,D3<=10000000),IF(OR(B3=\"M\",B3=\"F\"),IF(D3>5195890,G3*10%,MAX((D3-5000000),0)*70%),IF(D3>5195530,G3*10%,MAX((D3-5000000),0)*70%)),0),0),0)+IF(A3=\"2016-2017\",ROUND(IF(D3>10000000,IF(OR(B3=\"M\",B3=\"F\"),IF(D3>10646940,G3*15%,MAX((D3-10000000),0)*70%),IF(D3>10645800,G3*15%,MAX((D3-10000000),0)*70%)),0),0),0)","v":0},0,{"$f":"ROUND(IF(OR(A3=\"2019-2020\",A3=\"2018-2019\"),(I3*4%),(I3*3%)),0)","v":0},{"$f":"SUM(I3:J3)","v":0}]

{"sheet":"Income Slabs","index":3,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,14,9,14],[11,14,19,14],[1,6,9,6]]}
["FIN. YEAR","STATUS","Income From","Income Up to","Tax Rate","Tax Amount","Remarks",null,"FIN. YEAR","STATUS","Income From","Income Up to","Surcharge","Tax Amount","Remarks"]
["2019-2020","General",0,250000,0,0,"Income Tax Slab",null,"2019-2020","General",0,5000000,0,0,"Surcharge"]
["2019-2020","General",{"$f":"D2+1","v":250001},500000,5,{"$f":"ROUND((D3-C3)*E3%,0)","v":12500},null,null,"2019-2020","General",{"$f":"+L2+1","v":5000001},5195890,"Marginal",0]
["2019-2020","General",{"$f":"D3+1","v":500001},1000000,20,{"$f":"ROUND((D4-C4)*E4%,0)","v":100000},null,null,"2019-2020","General",{"$f":"+L3+1","v":5195891},10000000,10,0]
["2019-2020","General",1000001,">",30,{"$f":"F4+F3","v":112500},null,null,"2019-2020","General",{"$f":"+L4+1","v":10000001},10214700,"Marginal",281250]
[null,null,null,null,null,null,null,null,"2019-2020","General",10214701,20000000,15,0]
["2019-2020","Senior Citizen",0,300000,0,0,null,null,"2019-2020","General",20000001,20930000,"Marginal",871875]
["2019-2020","Senior Citizen",{"$f":"D7+1","v":300001},500000,5,{"$f":"ROUND((D8-C8)*E8%,0)","v":10000},null,null,"2019-2020","General",20930001,50000000,25,0]
["2019-2020","Senior Citizen",{"$f":"D8+1","v":500001},1000000,20,{"$f":"ROUND((D9-C9)*E9%,0)","v":100000},null,null,"2019-2020","General",50000001,53017830,"Marginal",3703125]
["2019-2020","Senior Citizen",1000001,">",30,{"$f":"F9+F8","v":110000},null,null,"2019-2020","General",53017831,">",0.37,0]
[]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",0,5000000,0,0,"Surcharge"]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",{"$f":"+L12+1","v":5000001},5195530,"Marginal",0]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",{"$f":"+L13+1","v":5195531},10000000,10,0]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",{"$f":"+L14+1","v":10000001},10214510,"Marginal",281000]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",10214511,20000000,15,0]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",20000001,20929600,"Marginal",871500]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",20929601,50000000,25,0]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",50000001,53017320,"Marginal",3702500]
[null,null,null,null,null,null,null,null,"2019-2020","Senior Citizen",53017321,">",0.37,0]